---
title: SQL catalog — SAIF.Business.Claim.Legal
summary: Catalog of individually-cited SQL statements and stored-procedure calls for the legal case-management domain.
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# SQL catalog

This library's Stage 1b database analysis cites **113 individual SQL findings** (DB-CLL-001 through DB-CLL-113) plus one consolidated code-table lookup group (DB-CLL-CT-001, ~30 variants). This catalog individually documents every distinctly-cited SQL finding from the Stage 1b database analysis (TSK1B-002), consolidating two large repeating groups to keep the set navigable: the ~30 code-table lookup variants in `mdlCodeTables.vb` are documented as a single consolidated entry (DB-CLL-CT-001), and the ~40 standard CRUD statements across 8 TableMaint reference-data objects are documented as a single consolidated entry (DB-CLL-065-104). Objects whose `IBusinessCriteria` properties throw `ApplicationException` (no SQL) are noted below and are not itemized as individual SQL documents.

This catalog documents **65 SQL pages** in total, covering all distinctly-cited findings.

## C

| SQL ID | Business object | Description | Page |
|---|---|---|---|
| DB-CLL-009 | clsAppeal | Generate the next appeal sequence value | [DB-CLL-009](SQL-009-appeal.md) |

## D

| SQL ID | Business object | Description | Page |
|---|---|---|---|
| DB-CLL-004 | clsCaseCost | Delete a case cost record | [DB-CLL-004](SQL-004-casecost.md) |
| DB-CLL-012 | clsAppeal | Delete an appeal record | [DB-CLL-012](SQL-012-appeal.md) |
| DB-CLL-019 | clsCaseNote | Delete a case note | [DB-CLL-019](SQL-019-casenote.md) |
| DB-CLL-023 | clsCaseOutcome | Delete a case outcome | [DB-CLL-023](SQL-023-caseoutcome.md) |
| DB-CLL-039 | clsLegalFileLocation | Delete a legal file location record | [DB-CLL-039](SQL-039-legalfilelocation.md) |
| DB-CLL-043 | clsLegalSchedule | Delete a legal schedule entry | [DB-CLL-043](SQL-043-legalschedule.md) |
| DB-CLL-049 | clsLegalCase | Delete a legal case header record | [DB-CLL-049](SQL-049-legalcase.md) |

## I

| SQL ID | Business object | Description | Page |
|---|---|---|---|
| DB-CLL-002 | clsCaseCost | Insert a new case cost record | [DB-CLL-002](SQL-002-casecost.md) |
| DB-CLL-010 | clsAppeal | Insert a new appeal record | [DB-CLL-010](SQL-010-appeal.md) |
| DB-CLL-014 | clsAppealExtension | Insert an appeal extension record | [DB-CLL-014](SQL-014-appealextension.md) |
| DB-CLL-017 | clsCaseNote | Insert a new case note | [DB-CLL-017](SQL-017-casenote.md) |
| DB-CLL-021 | clsCaseOutcome | Insert a new case outcome | [DB-CLL-021](SQL-021-caseoutcome.md) |
| DB-CLL-034 | clsLegalCaseEvaluation | Insert a legal case evaluation | [DB-CLL-034](SQL-034-legalcaseevaluation.md) |
| DB-CLL-037 | clsLegalFileLocation | Insert a legal file location record | [DB-CLL-037](SQL-037-legalfilelocation.md) |
| DB-CLL-041 | clsLegalSchedule | Insert a legal schedule entry | [DB-CLL-041](SQL-041-legalschedule.md) |
| DB-CLL-047 | clsLegalCase | Insert a new legal case header record | [DB-CLL-047](SQL-047-legalcase.md) |

## Misc

| SQL ID | Business object | Description | Page |
|---|---|---|---|
| DB-CLL-045 | clsLegalScheduleCollection | Retrieve the full schedule list for a legal case | [DB-CLL-045](SQL-045-legalschedulecollection.md) |
| DB-CLL-050 | clsLegalCase.UpdateHearingSeq | Update the hearing sequence number on a case | [DB-CLL-050](SQL-050-legalcase.md) |
| DB-CLL-052 | clsCreateFile.UpdateCreateFile | Stamp the file-create date on a legal case | [DB-CLL-052](SQL-052-createfile.md) |
| DB-CLL-054 | clsMailDate | Set the mail OAR flag on a legal case | [DB-CLL-054](SQL-054-maildate.md) |
| DB-CLL-055 | clsMailDate (list-level) | Batch-set the mail date across legal cases | [DB-CLL-055](SQL-055-maildate.md) |
| DB-CLL-056 | clsConsolidations | Update a case consolidation link | [DB-CLL-056](SQL-056-consolidations.md) |
| DB-CLL-057 | clsConsolidations | Cascade a case status update during consolidation | [DB-CLL-057](SQL-057-consolidations.md) |
| DB-CLL-058 | clsLetterRequest | Look up a case number for a printed letter | [DB-CLL-058](SQL-058-letterrequest.md) |
| DB-CLL-059 | clsAssignmentProcess.GetMaxSeq | Fetch the maximum assignment result sequence | [DB-CLL-059](SQL-059-assignmentprocess.md) |
| DB-CLL-060 | clsQuickCal | Trigger an Oracle-side calendar review | [DB-CLL-060](SQL-060-quickcal.md) |

## R

| SQL ID | Business object | Description | Page |
|---|---|---|---|
| DB-CLL-001 | clsCaseCost | Retrieve a single case cost by ID | [DB-CLL-001](SQL-001-casecost.md) |
| DB-CLL-006 | clsCaseCostCollection | Retrieve case cost list for a legal case | [DB-CLL-006](SQL-006-casecostcollection.md) |
| DB-CLL-007 | clsCaseStatusHistoryCollection | Retrieve case status history, newest first | [DB-CLL-007](SQL-007-casestatushistorycollection.md) |
| DB-CLL-013 | clsAppealCollection | Retrieve appeals for a legal case | [DB-CLL-013](SQL-013-appealcollection.md) |
| DB-CLL-016 | clsCaseNote | Retrieve case notes for a legal case | [DB-CLL-016](SQL-016-casenote.md) |
| DB-CLL-020 | clsCaseOutcomeCollection | Retrieve case outcomes for a legal case | [DB-CLL-020](SQL-020-caseoutcomecollection.md) |
| DB-CLL-024 | clsOutcomeIssue | Retrieve a single outcome issue | [DB-CLL-024](SQL-024-outcomeissue.md) |
| DB-CLL-025 | clsOutcomeIssue collection ctor | Retrieve the outcome issue list for an outcome | [DB-CLL-025](SQL-025-outcomeissue.md) |
| DB-CLL-026 | clsOutcomeStaff single | Retrieve a single outcome staff assignment | [DB-CLL-026](SQL-026-outcomestaff.md) |
| DB-CLL-027 | clsOutcomeStaff collection ctor | Retrieve the outcome staff list for an outcome | [DB-CLL-027](SQL-027-outcomestaff.md) |
| DB-CLL-028 | clsRequestIssue | Retrieve a single request issue | [DB-CLL-028](SQL-028-requestissue.md) |
| DB-CLL-029 | clsRequestIssue collection ctor | Retrieve the request issue list for a case | [DB-CLL-029](SQL-029-requestissue.md) |
| DB-CLL-030 | clsOtherLegalParty | Retrieve a single other-legal-party record | [DB-CLL-030](SQL-030-otherlegalparty.md) |
| DB-CLL-031 | clsOtherLegalParty collection ctor | Retrieve the other-legal-party list for a case | [DB-CLL-031](SQL-031-otherlegalparty.md) |
| DB-CLL-032 | clsHearingLocationInfo | Retrieve the full hearing-location lookup list | [DB-CLL-032](SQL-032-hearinglocationinfo.md) |
| DB-CLL-033 | clsLegalCaseEvaluation | Retrieve legal case evaluations | [DB-CLL-033](SQL-033-legalcaseevaluation.md) |
| DB-CLL-036 | clsLegalFileLocation | Retrieve file locations for a legal case | [DB-CLL-036](SQL-036-legalfilelocation.md) |
| DB-CLL-040 | clsLegalSchedule | Retrieve legal schedule entries for a case | [DB-CLL-040](SQL-040-legalschedule.md) |
| DB-CLL-044 | clsLegalSchedule | Resolve a secretary/ALJ display name for a schedule entry | [DB-CLL-044](SQL-044-legalschedule.md) |
| DB-CLL-046 | clsLegalCase | Retrieve a legal case header record | [DB-CLL-046](SQL-046-legalcase.md) |
| DB-CLL-051 | clsLegalCaseCollection | Retrieve the full legal case list | [DB-CLL-051](SQL-051-legalcasecollection.md) |
| DB-CLL-053 | clsCreateFile.GetNextDocSeqNum | Generate the next print-document sequence number | [DB-CLL-053](SQL-053-createfile.md) |
| DB-CLL-061 | clsLegalPerson.CanDeleteLegalPerson | Check referential-integrity blockers before delete | [DB-CLL-061](SQL-061-legalperson.md) |
| DB-CLL-062 | clsHearingLocation.CanDeleteLocation | Check whether a hearing location has active schedule rows | [DB-CLL-062](SQL-062-hearinglocation.md) |
| DB-CLL-063 | clsHearingLocation.ValidateState | Validate a state code (non-parameterized — flagged) | [DB-CLL-063](SQL-063-hearinglocation.md) |
| DB-CLL-064 | clsOtherFirm.ValidateState | Validate a state code (non-parameterized — flagged) | [DB-CLL-064](SQL-064-otherfirm.md) |
| DB-CLL-CT-001 | mdlCodeTables | Retrieve a code-table lookup list for dropdowns | [DB-CLL-CT-001](SQL-CT001-mdlcodetables.md) |

## R,I,U,D

| SQL ID | Business object | Description | Page |
|---|---|---|---|
| DB-CLL-065-104 | clsAttorneyConflict, clsAttorneyWorkerAssignment (+ clsAttorneyPolicyAssignment, clsAttorneySchedule), clsLegalPersonType, clsOtherFirm, clsOutOFTownRotationAssgn, clsHearingLocation | Standard reference-data CRUD across 8 TableMaint objects | [DB-CLL-065-104](SQL-065-104-attorneyconflict,.md) |

## U

| SQL ID | Business object | Description | Page |
|---|---|---|---|
| DB-CLL-003 | clsCaseCost | Update case cost amounts and details | [DB-CLL-003](SQL-003-casecost.md) |
| DB-CLL-008 | clsAcknowledge | Update an acknowledgement record for a case | [DB-CLL-008](SQL-008-acknowledge.md) |
| DB-CLL-011 | clsAppeal | Update an existing appeal record | [DB-CLL-011](SQL-011-appeal.md) |
| DB-CLL-015 | clsAppealExtension | Update an appeal extension record | [DB-CLL-015](SQL-015-appealextension.md) |
| DB-CLL-018 | clsCaseNote | Update an existing case note | [DB-CLL-018](SQL-018-casenote.md) |
| DB-CLL-022 | clsCaseOutcome | Update an existing case outcome | [DB-CLL-022](SQL-022-caseoutcome.md) |
| DB-CLL-035 | clsLegalCaseEvaluation | Update a legal case evaluation | [DB-CLL-035](SQL-035-legalcaseevaluation.md) |
| DB-CLL-038 | clsLegalFileLocation | Update a legal file location record | [DB-CLL-038](SQL-038-legalfilelocation.md) |
| DB-CLL-042 | clsLegalSchedule | Update a legal schedule entry | [DB-CLL-042](SQL-042-legalschedule.md) |
| DB-CLL-048 | clsLegalCase | Update a legal case header record | [DB-CLL-048](SQL-048-legalcase.md) |

## Objects with no direct SQL

The following business objects' `IBusinessCriteria` implementations intentionally throw `ApplicationException` for all CRUD members (retrieve-only/API-backed/DTO objects) or otherwise issue no direct SQL, per TSK1B-002 §2 (findings DB-CLL-105 through DB-CLL-113). They are not itemized as individual SQL pages because there is no SQL text to render:

- `clsAssignmentResults`, `clsAssignmentDetail`, `clsAssignmentReport` (`LegalNet\clsAssignmentResult.vb`)
- `clsBoardLog` (`LegalNet\clsBoardLog.vb`)
- `clsAttorneyMessages` (`LegalNet\clsAttorneyMessages.vb`)
- `clsCaseSearchCriteria`, `clsCaseSearchResult` (`LegalNet\clsFindCase.vb` family — search delegates to LegalApi)
- Print DTO classes under `Print\` (`Print\*.vb` — populated from LegalApi responses, no direct SQL)

## Related documentation

- [Database tables](../database-tables.md)
- [Business rules](../business-rules.md)
- [Operations and processes](../operations-processes.md)
- [Stored procedures](../procedures/index.md)
- [Architecture](../architecture.md)

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\` (all `.vb` files)
- `SAIF.Business.Claim.Legal\TableMaint\` (all `.vb` files)
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`